const Sequelize = require('sequelize')
const sequelize = require('../utils/db')

//定义表的模型
var Ad = sequelize.define('ad_customers', {
  AutoID: { //自增长id,主键,整形
    type: Sequelize.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  c_id: { //客户编号
    type: Sequelize.STRING(11)
  },
  c_name: { //客户名称
    type: Sequelize.STRING(11)
  },
  c_sex: { //客户名称
    type: Sequelize.STRING(11)
  },
  c_phone: { //客户名称
    type: Sequelize.STRING(11)
  },
  c_address: { //客户名称
    type: Sequelize.STRING(11)
  },
  c_age: { //客户名称
    type: Sequelize.STRING(11)
  },
}, {
  timestamps: false
});
Ad.sync(); //创建表

module.exports = Ad;

